Tabela Beneficiary

Definicja tabeli Beneficiary

Name

Beneficiary

Code

Beneficiary

Comment

PL: Dane beneficjenta
EN: Beneficiary data


Lista kolumn tabeli Beneficiary

Name

Code

PersonID

PersonID

CardKindID

CardKindID

BeneficiaryStatusID

BeneficiaryStatusID

CardNo

CardNo

StartDT

StartDT

StopDT

StopDT

SecretData

SecretData


Kolumna PersonID tabeli Beneficiary

Definicja kolumny PersonID tabeli Beneficiary

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna CardKindID tabeli Beneficiary

Definicja kolumny CardKindID tabeli Beneficiary

Name

CardKindID

Code

CardKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna BeneficiaryStatusID tabeli Beneficiary

Definicja kolumny BeneficiaryStatusID tabeli Beneficiary

Name

BeneficiaryStatusID

Code

BeneficiaryStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CardNo tabeli Beneficiary

Definicja kolumny CardNo tabeli Beneficiary

Name

CardNo

Code

CardNo

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna StartDT tabeli Beneficiary

Definicja kolumny StartDT tabeli Beneficiary

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Beneficiary

Definicja kolumny StopDT tabeli Beneficiary

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna SecretData tabeli Beneficiary

Definicja kolumny SecretData tabeli Beneficiary

Name

SecretData

Code

SecretData

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Lista kluczy tabeli Beneficiary

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Beneficiary

Definicja klucza Identifier_1 tabeli Beneficiary

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment